██    ██ ██    ██  ██████  ██  ██████  ██    ██ ███████ ██████  ██    ██ 
     ██  ██  ██    ██ ██       ██ ██    ██ ██    ██ ██      ██   ██  ██  ██  
      ████   ██    ██ ██   ███ ██ ██    ██ ██    ██ █████   ██████    ████   
       ██    ██    ██ ██    ██ ██ ██ ▄▄ ██ ██    ██ ██      ██   ██    ██    
       ██     ██████   ██████  ██  ██████   ██████  ███████ ██   ██    ██    
                                      ▀▀
Sets - Execution started 03/02/2023 16:18 UTC
By Guilherme Ruiz

Table of Contents¶

  • 1  Data aquisition
    • 1.1  Fetch set lists
    • 1.2  Fetch set properties
    • 1.3  Merge data
    • 1.4  Save data
  • 3  Check changes
    • 3.1  Load previous data
    • 3.2  Generate changelog
  • 4  Data visualization
    • 4.1  Full data
    • 4.2  Set
    • 4.3  Card number
    • 4.4  Name
    • 4.5  Rarity
      • 4.5.1  By unique
      • 4.5.2  By combination
    • 4.6  Print
    • 4.7  Quantity
    • 4.8  Region
    • 4.9  Cover card
    • 4.10  Series
    • 4.11  Set type
    • 4.12  Release
      • 4.12.1  By year
      • 4.12.2  By month
      • 4.12.3  By day
      • 4.12.4  By region
      • 4.12.5  By series
      • 4.12.6  By set type
  • 5  Debug
    • 5.1  Has nan name/number
    • 5.2  Has nan rarity
    • 5.3  Has quantity as print
    • 5.4  Has nan release
    • 5.5  Has print as rarity
    • 5.6  Merge failed
  • 6  Epilogue
    • 6.1  HTML export

Data aquisition¶

Fetch set lists¶

  0%|          | 0/80 [00:00<?, ?it/s]
4120 set lists received - 76 errors

Fetch set properties¶

  0%|          | 0/96 [00:00<?, ?it/s]
1430 set properties received - 3 errors

Merge data¶

Set properties merged

Save data¶

Data saved

Check changes¶

Load previous data¶

No older files

Generate changelog¶

Skipped

Data visualization¶

Full data¶

Set Card number Name Rarity Print Quantity Region Release Series Set type Cover card Page URL Modification date _merge
0 Absolute Powerforce: Special Edition ABPF-ITSE1 Dandylion (Super rare,) <NA> <NA> IT 2010-03-25 <NA> Special Edition NaN https://yugipedia.com/wiki/Absolute_Powerforce... 2017-05-18 05:26:53 both
1 Absolute Powerforce: Special Edition ABPF-ITSE2 Red-Eyes Darkness Metal Dragon (Super rare,) <NA> <NA> IT 2010-03-25 <NA> Special Edition NaN https://yugipedia.com/wiki/Absolute_Powerforce... 2017-05-18 05:26:53 both
2 Absolute Powerforce: Special Edition ABPF-ENSE1 Dandylion (Super rare,) <NA> <NA> EN 2010-03-26 <NA> Special Edition NaN https://yugipedia.com/wiki/Absolute_Powerforce... 2017-05-18 05:26:53 both
3 Absolute Powerforce: Special Edition ABPF-ENSE2 Red-Eyes Darkness Metal Dragon (Super rare,) <NA> <NA> EN 2010-03-26 <NA> Special Edition NaN https://yugipedia.com/wiki/Absolute_Powerforce... 2017-05-18 05:26:53 both
4 Absolute Powerforce: Special Edition ABPF-SPSE1 Dandylion (Super rare,) <NA> <NA> SP 2010-03-25 <NA> Special Edition NaN https://yugipedia.com/wiki/Absolute_Powerforce... 2017-05-18 05:26:53 both
... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
156159 Jump Festa 2004 promotional cards PC3-007 Bazoo the Soul-Eater (Common, Normal Parallel Rare) <NA> <NA> JP 2003-12-20 <NA> Tournament prize card NaN https://yugipedia.com/wiki/Jump_Festa_2004_pro... 2022-11-06 04:44:51 both
156160 Jump Festa 2005 promotional cards PC5-JP007 Dark Balter the Terrible (Common, Normal Parallel Rare) <NA> <NA> JP 2004-12-18 <NA> Promotional card NaN https://yugipedia.com/wiki/Jump_Festa_2005_pro... 2022-11-06 05:15:26 both
156161 Jump Festa 2005 promotional cards PC5-JP008 Ryu Senshi (Common, Normal Parallel Rare) <NA> <NA> JP 2004-12-18 <NA> Promotional card NaN https://yugipedia.com/wiki/Jump_Festa_2005_pro... 2022-11-06 05:15:26 both
156162 Academia Disk <NA> <NA> NaN <NA> <NA> <NA> NaT <NA> <NA> NaN https://yugipedia.com/wiki/Academia_Disk 2022-12-28 20:46:20 right_only
156163 Structure Deck: Marik (disambiguation) <NA> <NA> NaN <NA> <NA> <NA> NaT <NA> <NA> NaN https://yugipedia.com/wiki/Structure_Deck:_Mar... 2014-07-03 18:52:14 right_only

156164 rows × 14 columns

Full data available here

Set¶

Total number of sets: 1435
Card number Name Rarity Print Quantity Region Release Series Set type Cover card Page URL Modification date _merge
Set
"Amabie-San" Present Campaign 2 1 1 0 0 1 1 0 1 0 1 1 1
"Blue-Eyes White Dragon Rush Rare Special Red Version" GET Campaign 2 1 1 0 0 2 2 0 1 0 1 1 1
"Blue-Eyes White Dragon Secret Rare Special Blue Version" GET Campaign 1 1 1 0 0 1 1 0 1 0 1 1 1
"Blue-Eyes White Dragon" 20th Anniversary Gold Edition 0 1 1 0 0 1 1 0 1 0 1 1 1
"Blue-Eyes White Dragon" 20th Anniversary Silver Edition 0 1 1 0 0 1 1 0 1 0 1 1 1
... ... ... ... ... ... ... ... ... ... ... ... ... ...
Yu-Gi-Oh! ZEXAL World Duel Carnival Duel Champion Guide! promotional card 1 1 1 0 0 1 1 0 1 0 1 1 1
Yu-Gi-Oh! ZEXAL World Duel Carnival promotional cards 18 3 2 0 0 6 2 0 1 0 1 1 1
Yugi's Legendary Decks 650 112 3 0 0 5 2 0 1 0 1 1 1
Zexal Collection Tin 120 24 3 0 0 5 1 0 1 1 1 1 1
Zombie World Structure Deck 185 37 2 0 2 5 1 0 1 1 1 1 1

1435 rows × 13 columns

Card number Name Rarity Print Quantity Region Release Series Set type Cover card Page URL Modification date _merge
count 1435.000000 1435.000000 1435.000000 1435.000000 1435.000000 1435.000000 1435.000000 1435.000000 1435.000000 1435.000000 1435.000000 1435.000000 1435.0
mean 107.213240 27.551220 2.503833 0.357491 0.096864 2.696864 1.455052 0.390941 0.953310 0.310801 0.994425 0.994425 1.0
std 236.084401 45.358259 2.300132 0.818887 0.446227 2.298980 0.997155 0.488131 0.211047 0.462983 0.074483 0.074483 0.0
min 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 1.0
25% 1.000000 1.000000 1.000000 0.000000 0.000000 1.000000 1.000000 0.000000 1.000000 0.000000 1.000000 1.000000 1.0
50% 10.000000 5.000000 2.000000 0.000000 0.000000 1.000000 1.000000 0.000000 1.000000 0.000000 1.000000 1.000000 1.0
75% 86.000000 41.000000 3.000000 0.000000 0.000000 5.000000 2.000000 1.000000 1.000000 1.000000 1.000000 1.000000 1.0
max 1652.000000 307.000000 17.000000 6.000000 3.000000 10.000000 9.000000 1.000000 1.000000 1.000000 1.000000 1.000000 1.0

Card number¶

Total number of card numbers: 151985
Set Name Rarity Print Quantity Region Release Series Set type Cover card Page URL Modification date _merge
Card number
15AX-JP000 2 1 1 1 0 1 1 0 1 0 2 2 1
15AX-JPM01 1 1 1 1 0 1 1 0 1 0 1 1 1
15AX-JPM02 1 1 1 1 0 1 1 0 1 0 1 1 1
15AX-JPM03 1 1 1 1 0 1 1 0 1 0 1 1 1
15AX-JPM04 1 1 1 1 0 1 1 0 1 0 1 1 1
... ... ... ... ... ... ... ... ... ... ... ... ... ...
ZTIN-SP021 1 1 1 0 0 1 1 0 1 1 1 1 1
ZTIN-SPV01 1 1 1 0 0 1 1 0 1 1 1 1 1
ZTIN-SPV02 1 1 1 0 0 1 1 0 1 1 1 1 1
ZTIN-SPV03 1 1 1 0 0 1 1 0 1 1 1 1 1
<NA> 44 406 7 2 2 10 40 6 11 6 43 43 3

151986 rows × 13 columns

Name¶

Total number of card names: 12579
Set Card number Rarity Print Quantity Region Release Series Set type Cover card Page URL Modification date _merge
Name
"A Legendary Ocean" 1 1 0 0 0 1 1 0 1 1 1 1 1
"A" Cell Breeding Device 4 9 1 1 0 7 6 1 2 3 4 4 1
"A" Cell Incubator 2 8 1 2 0 7 6 1 1 2 2 2 1
"A" Cell Recombination Device 1 8 1 0 0 8 4 1 1 1 1 1 1
"A" Cell Scatter Burst 3 9 1 1 0 7 6 1 1 3 3 3 1
... ... ... ... ... ... ... ... ... ... ... ... ... ...
Zubaba Knight 12 50 5 1 1 8 23 2 2 7 12 12 1
Zubababancho Gagagacoat 1 2 1 1 0 2 2 1 1 1 1 1 1
Zure, Knight of Dark World 8 24 1 1 1 10 14 1 4 4 8 8 1
Zushin the Sleeping Giant 3 14 3 1 0 8 4 1 2 3 3 3 1
<NA> 8 145 3 0 0 9 11 3 4 3 8 8 2

12580 rows × 13 columns

Set Card number Rarity Print Quantity Region Release Series Set type Cover card Page URL Modification date _merge
count 12579.000000 12579.000000 12579.000000 12579.000000 12579.000000 12579.000000 12579.000000 12579.000000 12579.000000 12579.000000 12579.000000 12579.000000 12579.000000
mean 3.143016 12.072184 2.096431 0.682725 0.107481 6.893871 5.985611 1.090866 1.473408 1.843469 3.131727 3.131727 1.010812
std 3.515743 11.605423 1.537159 0.676641 0.336553 2.556428 5.904581 0.788348 0.936947 1.841657 3.495115 3.495115 0.103420
min 1.000000 0.000000 0.000000 0.000000 0.000000 1.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 1.000000
25% 1.000000 7.000000 1.000000 0.000000 0.000000 6.000000 3.000000 1.000000 1.000000 1.000000 1.000000 1.000000 1.000000
50% 2.000000 9.000000 2.000000 1.000000 0.000000 8.000000 4.000000 1.000000 1.000000 1.000000 2.000000 2.000000 1.000000
75% 4.000000 14.000000 3.000000 1.000000 0.000000 8.000000 7.000000 1.000000 2.000000 2.000000 4.000000 4.000000 1.000000
max 80.000000 275.000000 30.000000 4.000000 3.000000 15.000000 122.000000 12.000000 16.000000 41.000000 80.000000 80.000000 2.000000

Rarity¶

Total number of rarities: 61

By unique¶

Set Card number Name Print Quantity Region Release Series Set type Cover card Page URL Modification date _merge
Rarity
10000 Secret Rare 2 7 1 1 0 7 2 1 1 2 2 2 1
20th Secret Rare 15 133 132 3 0 1 12 3 3 6 15 15 1
20th Secret rare 1 2 2 0 0 1 1 0 1 0 1 1 1
Collector"s Rare 5 211 61 2 0 7 5 2 1 5 5 5 1
Collector's Rare 1 90 15 2 0 6 1 0 1 1 1 1 1
... ... ... ... ... ... ... ... ... ... ... ... ... ...
Ultra Rare 773 17900 3163 7 2 16 1042 32 26 277 771 771 2
Ultra Secret Rare 3 0 8 0 0 1 3 1 3 0 3 3 1
Ultra rare 51 134 77 0 0 8 69 4 8 2 51 51 1
c 1 330 55 0 0 6 2 0 1 1 1 1 1
NaN 14 348 206 0 0 4 11 2 2 2 13 13 3

62 rows × 13 columns

By combination¶

Set Card number Name Print Quantity Region Release Series Set type Cover card Page URL Modification date _merge
Rarity
(10000 Secret Rare,) 2 7 1 1 0 7 2 1 1 2 2 2 1
(20th Secret Rare,) 8 23 22 1 0 1 7 2 3 1 8 8 1
(20th Secret rare,) 1 2 2 0 0 1 1 0 1 0 1 1 1
(Common,) 521 70067 7915 5 3 16 853 23 22 243 519 519 2
(Common, Duel Terminal Normal Parallel Rare) 1 834 139 2 0 6 1 0 1 1 1 1 1
... ... ... ... ... ... ... ... ... ... ... ... ... ...
(Ultra Rare, Ultra Parallel Rare, Ultimate Rare) 5 5 5 0 0 1 3 2 1 3 5 5 1
(Ultra Secret Rare,) 3 0 8 0 0 1 3 1 3 0 3 3 1
(Ultra rare,) 51 134 77 0 0 8 69 4 8 2 51 51 1
(c,) 1 330 55 0 0 6 2 0 1 1 1 1 1
NaN 14 348 206 0 0 4 11 2 2 2 13 13 3

138 rows × 13 columns

Print¶

Total number of prints: 16
Set Card number Name Rarity Quantity Region Release Series Set type Cover card Page URL Modification date _merge
Print
American debut 1 3 3 1 0 1 1 0 1 1 1 1 1
European & Oceanian debut 1 6 6 1 0 1 1 0 1 0 1 1 1
European debut 12 146 146 5 0 2 10 0 2 1 12 12 1
Functional errata 1 2 2 1 0 1 1 0 1 1 1 1 1
New 233 11763 3990 52 3 11 250 19 13 129 231 231 2
New art 1 4 2 1 0 2 2 0 1 1 1 1 1
New artwork 10 74 15 5 0 7 12 3 4 4 10 10 1
New artwork (renamed) 1 3 3 1 0 1 1 0 1 0 1 1 1
North American debut 2 4 4 2 0 2 2 0 2 0 2 2 1
Oceanian debut 1 1 1 1 0 1 1 0 1 0 1 1 1
Reprint 229 14033 4316 51 3 11 246 18 12 127 227 227 2
Reprint (New Art) 2 2 1 2 0 2 2 1 1 1 2 2 1
Reprint (functional errata) 15 33 21 10 0 8 14 3 3 5 15 15 1
Reprint (new artwork) 1 1 1 1 0 1 1 0 1 1 1 1 1
Reprint (renamed) 2 76 76 6 0 1 2 1 1 0 2 2 1
TCG legal debut 1 1 1 1 0 1 1 1 1 1 1 1 1
<NA> 1349 126010 11439 122 3 16 1447 42 37 315 1341 1341 3

Quantity¶

Total number of quantities: 3
Set Card number Name Rarity Print Region Release Series Set type Cover card Page URL Modification date _merge
Quantity
1 66 8760 1167 10 2 11 108 1 5 45 65 65 2
2 65 839 165 4 2 11 108 1 5 44 64 64 2
3 8 64 20 1 2 8 11 0 3 6 8 8 1
<NA> 1372 142334 12503 136 16 16 1502 45 36 316 1364 1364 3

Region¶

Total number of regions: 16
Set Card number Name Rarity Print Quantity Release Series Set type Cover card Page URL Modification date _merge
Region
AE 34 1527 1493 12 0 2 31 2 7 19 34 34 1
AU 2 100 87 3 0 0 1 0 1 2 2 2 1
DE 455 20372 10393 54 4 3 381 12 18 219 454 454 2
EN 658 20184 10480 61 14 3 536 22 23 207 657 657 2
EU 25 543 456 9 3 0 16 2 9 6 25 25 1
FC 3 102 87 3 0 0 1 0 2 2 3 3 1
FR 448 19776 10380 56 4 3 375 14 18 219 447 447 2
IT 447 20051 10388 55 4 3 378 12 18 218 446 446 2
JA 3 185 185 8 0 0 3 2 2 3 3 3 1
JP 714 19087 11213 94 6 3 530 28 28 247 709 709 2
KR 383 15937 10755 60 4 3 333 16 15 224 378 378 2
NA 47 1526 1333 10 4 2 39 5 11 12 47 47 1
PT 204 12461 7823 46 4 3 165 8 10 120 204 204 1
SC 23 1237 1074 13 2 0 23 5 1 12 23 23 1
SP 417 19211 10285 54 4 3 356 9 17 205 416 416 2
TC 7 300 286 12 0 2 5 2 2 3 7 7 1
<NA> 2 0 0 0 0 0 0 0 0 0 2 2 1
Set Card number Name Rarity Print Quantity Release Series Set type Cover card Page URL Modification date _merge
count 17.000000 17.000000 17.000000 17.000000 17.000000 17.000000 17.000000 17.000000 17.000000 17.000000 17.000000 17.000000 17.000000
mean 227.764706 8976.411765 5101.058824 32.352941 3.117647 1.764706 186.647059 8.176471 10.705882 101.058824 226.882353 226.882353 1.411765
std 254.359620 9337.505656 5031.318359 28.713980 3.461978 1.393261 205.059120 8.225230 8.716111 106.359338 253.258238 253.258238 0.507300
min 2.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 2.000000 2.000000 1.000000
25% 7.000000 300.000000 286.000000 9.000000 0.000000 0.000000 5.000000 2.000000 2.000000 3.000000 7.000000 7.000000 1.000000
50% 47.000000 1527.000000 1493.000000 13.000000 4.000000 2.000000 39.000000 5.000000 10.000000 19.000000 47.000000 47.000000 1.000000
75% 447.000000 19211.000000 10388.000000 55.000000 4.000000 3.000000 375.000000 12.000000 18.000000 218.000000 446.000000 446.000000 2.000000
max 714.000000 20372.000000 11213.000000 94.000000 14.000000 3.000000 536.000000 28.000000 28.000000 247.000000 709.000000 709.000000 2.000000

Cover card¶

Total number of cover cards: 671
Set Card number Name Rarity Print Quantity Region Release Series Set type Page URL Modification date _merge
Cover card
A-to-Z-Dragon Buster Cannon 1 352 54 4 2 2 8 4 0 1 1 1 1
Accel Synchro Stardust Dragon 1 100 50 3 2 0 2 2 0 1 1 1 1
Accesscode Talker 1 766 101 16 2 0 8 3 1 1 1 1 1
Adamancipator Risen - Dragite 1 135 45 3 2 0 3 3 0 1 1 1 1
Adreus, Keeper of Armageddon 1 84 42 4 0 0 2 2 0 1 1 1 1
... ... ... ... ... ... ... ... ... ... ... ... ... ...
Yamiterasu the Divine Ruler 1 132 66 6 0 0 2 2 1 1 1 1 1
Yoko, the Graceful Mayakashi 2 450 60 4 2 0 8 3 0 1 2 2 1
Yubel - The Ultimate Nightmare 2 560 100 10 0 0 6 5 1 2 2 2 1
Z-Metal Tank 1 55 55 7 0 0 1 1 1 1 1 1 1
Zerrziel, Ruler of the Evil Eyed 1 90 45 3 2 0 2 2 0 1 1 1 1

671 rows × 13 columns

Series¶

Total number of series: 45
Set Card number Name Rarity Print Quantity Region Release Set type Cover card Page URL Modification date _merge
Series
+1 Bonus Pack 7 249 137 3 0 0 2 12 1 0 7 7 1
Animation Chronicle 2 200 100 7 2 0 2 4 1 2 2 2 1
Astral Pack 7 1110 184 4 4 0 6 16 1 0 7 7 1
Attribute Duelist Pack 4 429 199 6 3 0 3 9 1 4 4 4 1
Battle Pack (Rush Duel) 8 80 80 3 3 0 1 8 1 0 8 8 1
Booster (series) 4 181 176 7 2 0 1 4 1 2 4 4 1
Booster pack 1 50 50 3 0 0 1 1 1 0 1 1 1
Champion Pack 8 640 161 4 2 0 4 8 1 0 8 8 1
Classic Pack 3 570 427 9 2 0 1 3 1 2 3 3 1
Collectors Pack 8 794 374 12 3 0 3 16 1 8 8 8 1
Core Booster 88 49929 7471 41 2 0 13 296 1 80 88 88 1
Deck Build Pack 3 360 134 3 2 0 3 8 1 3 3 3 1
Deck Mod Pack 12 1447 756 8 0 0 2 23 1 12 12 12 1
Duelist Pack 21 3739 634 7 3 0 8 49 1 19 21 21 1
Entry Pack (series) 10 163 160 3 2 0 1 10 1 0 10 10 1
Expansion Pack 4 280 280 6 0 0 1 4 1 0 4 4 1
Gold Series (series) 8 2595 446 9 2 0 9 18 1 0 8 8 1
Hidden Arsenal (series) 7 2470 400 2 2 0 7 16 1 7 7 7 1
Hobby League 1 83 43 3 0 0 5 0 1 0 1 1 1
Jump Victory Carnival 1 1 1 1 0 0 1 1 1 0 1 1 1
Legend Duelist (series) 6 780 343 10 2 0 3 14 1 6 6 6 1
Legendary Collection (series) 2 57 19 1 2 0 3 4 1 0 2 2 1
Master Guide promotional cards (series) 4 8 8 1 0 0 1 4 1 0 4 4 1
Mattel Action Figure promotional cards 3 17 16 1 0 0 1 3 1 0 3 3 1
McDonald's Promotional Cards 2 35 35 4 3 0 2 2 1 0 2 2 1
Monster Figure Collection promotional cards 3 15 15 1 0 0 1 3 1 0 3 3 1
OTS Tournament Pack 2 324 54 4 0 0 6 3 1 0 2 2 1
Perfect Rulebook promotional cards 3 3 3 2 0 0 1 3 1 0 3 3 1
Pharaoh Tour promotional cards 3 20 5 2 0 0 4 3 1 0 3 3 1
Premium Pack 25 452 368 8 3 0 2 25 1 12 25 25 1
Shonen Jump promotional cards 78 85 81 2 0 0 2 44 1 0 78 78 1
Sneak Peek Participation Cards 57 302 61 4 0 0 8 69 1 0 57 57 1
Star Pack 3 900 149 4 0 0 6 6 1 3 3 3 1
Structure Deck R 3 248 122 4 2 2 2 6 1 3 3 3 1
The Valuable Book promotional cards 18 38 38 2 0 0 2 19 1 0 18 18 1
V Jump August 1999 Special Present 1 0 6 1 0 0 1 1 1 0 1 1 1
V Jump Edition (series) 4 16 16 3 0 0 1 4 1 0 4 4 1
V Jump promotional cards 78 94 98 6 0 0 1 74 1 0 78 78 1
Value Box 9 11 11 3 0 0 1 7 1 0 9 9 1
Yu-Gi-Oh! 5D's manga promotional cards 9 19 9 2 0 0 3 18 1 0 9 9 1
Yu-Gi-Oh! Day promotional cards 7 7 1 1 0 0 2 7 1 0 7 7 1
Yu-Gi-Oh! GX manga promotional cards 9 19 9 3 0 0 3 17 1 0 9 9 1
Yu-Gi-Oh! R promotional cards 4 8 4 2 0 0 2 8 1 0 4 4 1
Yu-Gi-Oh! World Championship prize cards 13 35 30 5 0 0 3 13 1 0 13 13 1
Yu-Gi-Oh! ZEXAL manga promotional cards 8 25 8 1 0 0 4 25 1 0 8 8 1

Set type¶

Total number of set types: 37
Set Card number Name Rarity Print Quantity Region Release Series Cover card Page URL Modification date _merge
Set type
Beta set 1 535 106 1 0 2 5 1 0 0 1 1 1
Binder 2 6 6 2 2 0 1 2 0 0 2 2 1
Book promotional card 4 5 5 3 0 0 2 4 1 0 4 4 1
Book promotional cards 26 52 52 4 0 0 2 27 2 0 26 26 1
Booster pack 467 114012 11765 114 15 0 14 809 23 223 467 467 1
Boss Duel Deck 1 8 8 1 0 0 1 1 0 0 1 1 1
Bundle 9 11 11 3 0 0 1 7 1 0 9 9 1
Collectible tin 53 5901 1005 11 4 0 8 66 0 35 53 53 1
Collector's Set 11 6226 1102 7 2 3 7 14 0 6 11 11 1
Core Booster 1 160 80 6 0 0 2 2 0 1 1 1 1
Deluxe Edition 4 114 19 2 0 0 6 8 0 4 4 4 1
Demo Deck 4 380 64 1 0 0 7 8 0 1 4 4 1
Duel Disk 2 16 9 2 2 0 2 4 0 0 2 2 1
Duel Disk promotional cards 5 13 12 4 0 0 2 5 0 0 5 5 1
Duel Terminal 34 1847 706 6 2 0 2 31 0 10 34 34 1
Duelist League participation cards 10 60 16 3 0 0 9 9 0 0 10 10 1
Duelist Set 5 312 154 5 0 2 2 5 0 5 5 5 1
Enhancement Pack 2 20 20 1 0 0 1 1 0 0 2 2 1
Hobby League participation cards 40 83 43 3 0 0 5 38 0 0 40 40 1
Magazine promotional card 167 191 173 9 0 0 3 127 3 7 167 167 1
Magazine promotional cards 4 4 4 2 0 0 2 2 0 0 4 4 1
Main Deck 2 44 44 2 0 0 1 2 0 1 2 2 1
Manga promotional card 33 74 32 3 0 0 4 69 4 0 33 33 1
Participation card 60 485 119 8 0 0 9 71 2 0 60 60 1
Preconstructed Deck 6 401 223 10 3 0 2 8 0 4 6 6 1
Prize card 16 46 41 5 0 0 3 16 1 0 16 16 1
Prize cards 1 68 20 1 0 0 5 1 0 0 1 1 1
Promotional card 140 315 206 22 3 0 9 141 6 21 140 140 1
Promotional cards 25 200 62 10 2 0 10 34 1 1 25 25 1
Special Edition 90 1189 289 12 5 0 10 109 0 1 90 90 1
Starter Deck 38 6777 606 10 2 3 14 59 0 26 38 38 1
Structure Deck 64 9454 1206 8 2 3 10 117 1 45 64 64 1
Tournament prize card 1 2 2 1 0 0 1 1 0 0 1 1 1
Tournament promotional card 2 5 2 2 0 0 2 2 0 0 2 2 1
Vendor Edition 6 210 210 2 0 0 1 6 0 0 6 6 1
Video game promotional card 9 79 39 5 0 0 8 15 0 0 9 9 1
Video games promotional card 23 325 73 7 2 0 9 43 0 0 23 23 1

Release¶

Total number of release dates: 1573
Set Card number Name Rarity Print Quantity Region Series Set type Cover card Page URL Modification date _merge
Release
1999-03-01 1 0 40 2 2 0 1 1 1 0 1 1 1
1999-03-18 1 0 1 1 0 0 1 0 1 0 1 1 1
1999-04-29 1 0 1 1 0 0 1 0 1 0 1 1 1
1999-05-05 1 0 1 1 0 0 1 0 1 0 1 1 1
1999-05-25 1 0 40 2 0 0 1 1 1 0 1 1 1
... ... ... ... ... ... ... ... ... ... ... ... ... ...
2023-01-26 1 1 1 1 0 0 1 0 1 0 1 1 1
2023-02-25 1 190 47 5 2 0 1 1 1 0 1 1 1
2023-03-01 3 2 3 3 0 0 1 0 1 0 3 3 1
2023-05-01 3 3 3 1 0 0 1 0 1 0 3 3 1
NaT 119 3971 1085 25 4 2 13 9 13 14 111 111 3

1574 rows × 13 columns

By year¶

Set Card number Name Rarity Print Quantity Region Series Set type Cover card Page URL _merge
Release
1999 18 0 353 28 10 2 15 8 15 1 18 15
2000 12 274 324 21 9 2 10 8 11 5 12 10
2001 12 305 307 30 4 4 12 4 11 6 12 12
2002 22 1369 1197 81 10 2 21 9 20 14 22 19
2003 51 2669 2263 125 12 0 52 12 41 29 51 38
2004 93 6502 4687 198 6 0 108 27 74 45 93 59
2005 75 7826 4043 165 27 18 127 28 64 37 75 49
2006 101 5241 3045 186 22 20 125 39 92 42 101 67
2007 126 5744 3344 283 16 18 192 53 115 54 126 94
2008 124 5979 3248 276 21 12 194 51 113 50 124 95
2009 117 5104 2973 284 6 14 172 40 111 54 117 93
2010 138 6093 3322 320 8 16 204 58 124 53 138 103
2011 144 6922 3952 326 16 18 214 55 133 53 144 105
2012 141 10271 5425 357 17 20 218 57 128 53 141 111
2013 146 8913 4469 344 18 24 222 68 129 69 146 108
2014 141 12625 5705 388 38 20 225 68 126 60 141 107
2015 136 10432 4828 358 33 12 221 69 125 57 136 103
2016 137 10356 4755 337 39 10 210 62 124 59 137 97
2017 67 8404 3324 199 27 6 140 29 64 35 67 54
2018 46 5413 2129 141 26 0 103 20 41 28 46 41
2019 50 6264 2670 162 29 0 101 17 45 25 50 43
2020 38 6435 2143 151 34 0 85 18 36 27 38 36
2021 65 6812 2733 241 46 6 91 38 53 36 65 49
2022 73 8953 3698 250 66 3 96 43 61 42 73 56
2023 15 798 356 42 7 0 15 7 9 4 15 9

By month¶

By day¶

By region¶

Set Card number Name Rarity Print Quantity Series Set type Cover card Page URL Modification date _merge
Region Release
AE 2001-06-04 1 0 2 1 0 0 0 0 0 1 1 1
2002-08-08 2 100 87 3 0 0 0 1 2 2 2 1
2002-10-24 1 144 144 5 0 0 1 1 1 1 1 1
2003-04-17 1 3 3 1 0 0 0 1 0 1 1 1
2003-06-26 1 105 105 5 0 0 1 1 1 1 1 1
... ... ... ... ... ... ... ... ... ... ... ... ... ...
TC 2014-01-29 1 40 40 4 0 2 0 1 1 1 1 1
2014-05-01 1 20 20 4 0 0 1 1 0 1 1 1
2015-03-01 2 40 26 1 0 0 0 0 0 2 2 1
2015-08-29 1 100 100 6 0 0 1 1 1 1 1 1
2015-12-05 1 100 100 6 0 0 1 1 1 1 1 1

3173 rows × 12 columns

Release 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Region
AE 0 0 1 3 4 3 3 5 2 1 4 1 1 1 1 1 1 0 0 0 0 0 0 0 0
AU 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
DE 0 0 0 0 8 21 22 17 31 27 23 28 31 30 28 30 27 28 20 15 13 10 8 7 1
EN 0 0 2 2 3 16 29 48 50 45 33 45 47 49 42 43 34 35 20 15 13 10 12 11 2
EU 0 0 0 2 2 4 0 0 0 2 0 2 0 0 0 2 2 1 0 0 0 0 0 0 0
FC 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
FR 0 0 0 0 5 20 22 17 31 27 23 27 28 30 29 28 27 28 19 15 13 10 8 7 1
IT 0 0 0 0 5 20 21 17 31 27 23 27 29 30 28 28 27 28 20 15 13 10 8 7 1
JA 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0
JP 18 12 9 11 11 20 24 26 32 40 40 49 46 44 49 43 43 52 14 16 20 14 25 26 10
KR 0 0 0 0 2 8 7 13 20 24 21 21 30 29 29 23 22 21 17 10 12 10 23 26 1
NA 0 0 0 5 16 6 0 2 2 1 2 1 1 0 0 2 3 0 2 0 0 0 0 0 0
PT 0 0 0 0 0 10 6 0 0 0 0 0 0 1 24 24 25 26 18 14 13 9 8 7 1
SC 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4 7 10 2
SP 0 0 0 0 4 20 20 10 24 22 21 27 27 30 28 28 27 28 19 14 13 10 9 7 1
TC 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 4 0 0 0 0 0 0 0 0

By series¶

Set Card number Name Rarity Print Quantity Region Set type Cover card Page URL Modification date _merge
Series Release
+1 Bonus Pack 2020-10-31 1 19 19 3 0 0 1 1 0 1 1 1
2021-02-04 1 20 20 3 0 0 1 1 0 1 1 1
2021-04-17 1 19 19 3 0 0 1 1 0 1 1 1
2021-07-17 1 19 19 3 0 0 1 1 0 1 1 1
2021-07-21 1 19 19 3 0 0 1 1 0 1 1 1
... ... ... ... ... ... ... ... ... ... ... ... ... ...
Yu-Gi-Oh! ZEXAL manga promotional cards 2015-09-01 1 1 1 1 0 0 1 1 0 1 1 1
2015-10-03 1 1 1 1 0 0 1 1 0 1 1 1
2015-12-18 1 1 1 1 0 0 1 1 0 1 1 1
2016-03-01 1 1 1 1 0 0 1 1 0 1 1 1
2016-09-06 1 1 1 1 0 0 1 1 0 1 1 1

888 rows × 12 columns

Release 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Series
+1 Bonus Pack 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 6 4 1
Animation Chronicle 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 2 0
Astral Pack 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5 8 3 0 0 0 0 0 0 0 0
Attribute Duelist Pack 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 3 4 0
Battle Pack (Rush Duel) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 4 1
Booster (series) 0 3 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Booster pack 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Champion Pack 0 0 0 0 0 0 0 1 3 3 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Classic Pack 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1
Collectors Pack 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 2 2 2 2 2 2 2 0 0 0
Core Booster 6 0 2 6 11 22 17 17 25 13 14 15 14 16 18 16 17 16 12 10 8 6 8 8 1
Deck Build Pack 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 6 0
Deck Mod Pack 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4 9 8 2
Duelist Pack 0 0 0 0 0 0 2 9 9 10 4 6 7 3 3 1 3 5 1 0 0 0 0 0 0
Entry Pack (series) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 4 4 1
Expansion Pack 0 0 0 0 0 0 0 0 0 3 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0
Gold Series (series) 0 0 0 0 0 0 0 0 0 2 0 2 3 2 0 5 2 2 0 0 0 0 0 0 0
Hidden Arsenal (series) 0 0 0 0 0 0 0 0 0 0 1 3 6 3 3 0 0 0 0 0 0 0 0 0 0
Jump Victory Carnival 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0
Legend Duelist (series) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 4 4 1 1 1 0
Legendary Collection (series) 0 0 0 0 0 0 0 0 0 0 0 2 2 0 0 0 0 0 0 0 0 0 0 0 0
Master Guide promotional cards (series) 0 0 0 0 0 1 0 0 0 1 0 0 1 0 0 1 0 0 0 0 0 0 0 0 0
Mattel Action Figure promotional cards 0 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
McDonald's Promotional Cards 0 0 0 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Monster Figure Collection promotional cards 0 0 0 0 0 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0
OTS Tournament Pack 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 0 0 0 0 0
Perfect Rulebook promotional cards 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 0 0 0 0 0 0 0
Pharaoh Tour promotional cards 0 0 0 0 0 0 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Premium Pack 0 3 1 0 0 3 1 1 1 2 2 2 1 2 2 2 2 0 0 0 0 0 0 0 0
Shonen Jump promotional cards 0 0 0 0 0 0 2 3 4 3 2 7 2 4 4 6 4 6 1 0 0 0 0 0 0
Sneak Peek Participation Cards 0 0 0 0 0 0 4 4 9 8 3 4 4 5 4 4 4 5 5 3 2 1 0 0 0
Star Pack 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 1 2 0 0 0 0 0 0 0 0
Structure Deck R 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 4 1 0 0 0 0 0 0
The Valuable Book promotional cards 1 1 0 2 1 1 1 1 1 1 1 1 1 1 2 1 1 0 1 0 0 0 0 0 0
V Jump August 1999 Special Present 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
V Jump Edition (series) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 1 1 0 0 0 0
V Jump promotional cards 0 0 0 0 0 0 0 0 0 5 7 7 7 8 10 8 11 13 2 0 0 0 0 0 0
Value Box 0 0 0 0 0 0 0 0 0 0 0 0 1 2 4 1 1 0 0 0 0 0 0 0 0
Yu-Gi-Oh! 5D's manga promotional cards 0 0 0 0 0 0 0 0 0 0 0 2 2 3 4 3 3 1 0 0 0 0 0 0 0
Yu-Gi-Oh! Day promotional cards 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 2 2 1 0 0 0 0 0 0
Yu-Gi-Oh! GX manga promotional cards 0 0 0 0 0 0 0 1 2 3 3 4 3 2 0 0 0 0 0 0 0 0 0 0 0
Yu-Gi-Oh! R promotional cards 0 0 0 0 0 0 1 1 1 1 1 3 0 0 0 0 0 0 0 0 0 0 0 0 0
Yu-Gi-Oh! World Championship prize cards 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0 0 0 0
Yu-Gi-Oh! ZEXAL manga promotional cards 0 0 0 0 0 0 0 0 0 0 0 0 0 4 6 6 7 2 0 0 0 0 0 0 0

By set type¶

Set Card number Name Rarity Print Quantity Region Series Cover card Page URL Modification date _merge
Set type Release
Beta set 2017-10-04 1 535 106 1 0 2 5 0 0 1 1 1
Binder 2012-09-21 1 3 3 1 2 0 1 0 0 1 1 1
2015-04-29 1 3 3 1 0 0 1 0 0 1 1 1
Book promotional card 2004-12-18 1 2 2 1 0 0 1 0 0 1 1 1
2014-04-04 1 1 1 1 0 0 1 1 0 1 1 1
... ... ... ... ... ... ... ... ... ... ... ... ... ...
Video games promotional card 2011-04-28 1 7 7 1 0 0 1 0 0 1 1 1
2011-05-10 1 3 3 1 0 0 1 0 0 1 1 1
2013-12-05 1 3 3 1 0 0 1 0 0 1 1 1
2014-06-26 1 15 3 2 0 0 5 0 0 1 1 1
2016-07-16 1 1 1 1 0 0 1 0 0 1 1 1

1865 rows × 12 columns

Release 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Set type
Beta set 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0
Binder 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 1 0 0 0 0 0 0 0 0
Book promotional card 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 1 1 0 0 0 0 0 0 0
Book promotional cards 1 2 0 2 1 2 1 1 1 2 1 1 2 1 3 2 2 1 1 0 0 0 0 0 0
Booster pack 6 7 4 10 15 40 34 36 44 43 35 48 53 54 59 65 56 52 38 28 31 31 52 53 8
Boss Duel Deck 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0
Bundle 0 0 0 0 0 0 0 0 0 0 0 0 1 2 4 1 1 0 0 0 0 0 0 0 0
Collectible tin 0 0 0 1 2 2 2 3 3 7 10 6 5 4 7 2 2 2 2 1 2 1 1 1 0
Collector's Set 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 2 0 0 3 2 1 4 0
Core Booster 0 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Deluxe Edition 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 6 0 0 0 0 0 0 0 0 0
Demo Deck 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 2 2 0 3 0 0 0 0 0
Duel Disk 0 0 0 0 0 0 0 1 1 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0
Duel Disk promotional cards 0 0 0 0 0 0 0 1 1 0 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Duel Terminal 0 0 0 0 0 0 0 0 0 6 4 7 6 9 2 0 0 0 0 0 0 0 0 0 0
Duelist League participation cards 0 0 0 0 4 4 2 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Duelist Set 0 0 0 0 0 0 0 0 0 0 0 0 0 3 5 1 0 0 0 0 0 0 0 0 0
Enhancement Pack 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0
Hobby League participation cards 0 0 0 0 0 2 1 13 12 12 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Magazine promotional card 1 0 0 0 0 0 3 3 4 10 10 17 10 13 14 14 15 20 3 0 0 0 0 0 0
Magazine promotional cards 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Main Deck 0 0 0 0 0 0 0 0 0 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0
Manga promotional card 0 0 0 1 0 0 1 4 3 4 4 9 5 9 10 9 10 3 0 0 0 0 0 0 0
Participation card 1 0 0 0 0 0 4 4 9 8 4 5 4 5 4 4 4 5 5 3 2 1 0 0 0
Preconstructed Deck 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 0 0 4 0
Prize card 0 0 2 0 0 1 1 1 1 1 1 1 2 1 1 1 1 1 0 0 0 0 0 0 0
Prize cards 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0
Promotional card 2 0 2 1 0 1 1 8 8 5 7 14 19 8 5 5 7 17 5 3 6 2 9 11 7
Promotional cards 2 0 1 1 5 7 2 1 0 0 1 4 3 1 3 2 1 0 0 0 1 0 0 0 0
Special Edition 0 0 0 0 2 3 3 7 12 11 13 8 8 12 2 3 7 8 7 4 2 1 0 0 0
Starter Deck 1 1 0 4 13 18 2 0 3 2 5 4 3 4 8 5 7 4 0 0 0 0 2 0 0
Structure Deck 0 0 2 1 3 0 8 10 8 6 7 6 9 9 8 11 13 17 4 0 0 0 0 0 0
Tournament prize card 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Tournament promotional card 0 0 0 0 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Vendor Edition 0 0 0 0 0 1 2 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Video game promotional card 1 2 0 0 0 0 0 0 5 0 3 4 2 0 0 0 0 0 0 0 0 0 0 0 0
Video games promotional card 0 0 0 1 3 8 7 4 8 4 3 0 4 0 1 1 0 1 0 0 0 0 0 0 0

Debug¶

This section is used for debugging the extraction of data from MediaWiki query responses

Has nan name/number¶

Set Card number Name Rarity Print Quantity Region Release Series Set type Cover card Page URL Modification date _merge
13898 Yugi's Legendary Decks <NA> Glory of the King's Hand (Ultra Rare,) <NA> <NA> PT 2015-11-13 <NA> Collector's Set NaN https://yugipedia.com/wiki/Yugi%27s_Legendary_... 2022-01-20 12:42:52 both
13899 Yugi's Legendary Decks <NA> Set Sail for The Kingdom (Ultra Rare,) <NA> <NA> PT 2015-11-13 <NA> Collector's Set NaN https://yugipedia.com/wiki/Yugi%27s_Legendary_... 2022-01-20 12:42:52 both
13900 Yugi's Legendary Decks <NA> Duelist Kingdom (Ultra Rare,) <NA> <NA> PT 2015-11-13 <NA> Collector's Set NaN https://yugipedia.com/wiki/Yugi%27s_Legendary_... 2022-01-20 12:42:52 both
14031 Yugi's Legendary Decks <NA> Glory of the King's Hand (Ultra Rare,) <NA> <NA> DE 2015-11-12 <NA> Collector's Set NaN https://yugipedia.com/wiki/Yugi%27s_Legendary_... 2022-01-20 12:42:52 both
14032 Yugi's Legendary Decks <NA> Set Sail for The Kingdom (Ultra Rare,) <NA> <NA> DE 2015-11-12 <NA> Collector's Set NaN https://yugipedia.com/wiki/Yugi%27s_Legendary_... 2022-01-20 12:42:52 both
... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
145181 EX Starter Box <NA> De-Spell (Common,) Reprint 2 JP 1999-12-16 <NA> Starter Deck (Blue-Eyes White Dragon,) https://yugipedia.com/wiki/EX_Starter_Box 2022-05-01 06:51:59 both
145182 EX Starter Box <NA> Castle Walls (Common,) Reprint 1 JP 1999-12-16 <NA> Starter Deck (Blue-Eyes White Dragon,) https://yugipedia.com/wiki/EX_Starter_Box 2022-05-01 06:51:59 both
145183 EX Starter Box <NA> Ultimate Offering (Common,) Reprint 1 JP 1999-12-16 <NA> Starter Deck (Blue-Eyes White Dragon,) https://yugipedia.com/wiki/EX_Starter_Box 2022-05-01 06:51:59 both
156162 Academia Disk <NA> <NA> NaN <NA> <NA> <NA> NaT <NA> <NA> NaN https://yugipedia.com/wiki/Academia_Disk 2022-12-28 20:46:20 right_only
156163 Structure Deck: Marik (disambiguation) <NA> <NA> NaN <NA> <NA> <NA> NaT <NA> <NA> NaN https://yugipedia.com/wiki/Structure_Deck:_Mar... 2014-07-03 18:52:14 right_only

704 rows × 14 columns

Has nan rarity¶

array(['Advanced Tournament Pack 2013 Vol.3', 'Dark Beginning 1',
       'Dark Beginning 2', 'V Jump April 2013 Tokens',
       'Advanced Event Pack 2013 Vol.2', 'Dark Revelation Volume 1',
       'Advanced Event Pack 2014 Vol.1', 'Dark Revelation Volume 2',
       'Advanced Tournament Pack 2016 Vol.1',
       'Advanced Tournament Pack 2013 Vol.4',
       'The Valuable Book character cards', 'Classic Pack 03',
       'Academia Disk', 'Structure Deck: Marik (disambiguation)'],
      dtype=object)

Has nan release¶

array(['Secrets of Eternity Sneak Peek Participation Card',
       'Astral Pack Two',
       'The New Challengers Sneak Peek Participation Card', 'Gold Series',
       'Premium Pack', 'Banzai! promotional cards',
       'Dimension of Chaos Sneak Peek Participation Card', 'Magic Ruler',
       'Raging Battle Sneak Peek Participation Card',
       "Yu-Gi-Oh! 5D's Volume 1 promotional card",
       "Yu-Gi-Oh! 5D's Wheelie Breakers promotional cards",
       'Yu-Gi-Oh! The Official Magazine promotional cards',
       'Shonen Jump Vol. 10, Issue 1 promotional card',
       'Yu-Gi-Oh! Worldwide Edition: Stairway to the Destined Duel promotional cards',
       'Hobby League 7 participation card D', 'Premium Pack 2',
       'Legacy of the Valiant Sneak Peek Participation Card',
       'Shadow Specters Sneak Peek Participation Card',
       'Shonen Jump Vol. 4, Issue 11 promotional card',
       "Yu-Gi-Oh! 5D's World Championship 2011: Over the Nexus promotional cards",
       'Shonen Jump Vol. 7, Issue 6 promotional card',
       'Tournament Pack 2008 Vol.1',
       'Yu-Gi-Oh! GX Volume 4 promotional card',
       'Yu-Gi-Oh! Power of Chaos: Kaiba the Revenge promotional cards',
       'Hobby League 6 participation card E', 'Millennium Pack',
       'Academy Duel Disk', 'Astral Pack One',
       'The Lost Millennium: Special Edition', 'Structure Deck: Marik',
       'Shonen Jump May 2006 subscription bonus',
       'Shonen Jump Vol. 10, Issue 3 promotional card',
       'Yu-Gi-Oh! GX manga promotional cards',
       'Crossed Souls Sneak Peek Participation Card',
       'Shonen Jump Vol. 3, Issue 6 promotional card',
       'Shonen Jump Vol. 4, Issue 12 promotional card',
       'Sneak Peek Participation Cards',
       'Yu-Gi-Oh! Championship Series Prize Cards',
       'Tournament Pack 2008 Vol.2',
       'Shonen Jump Vol. 9, Issue 4 promotional card', 'Spell Ruler',
       'Hobby League 6 participation card F',
       'Shadow of Infinity: Special Edition',
       'Ancient Prophecy Sneak Peek Participation Card',
       'Duelist League Demo 2010',
       'Shonen Jump December 2010 subscription bonus',
       'Shonen Jump Vol. 6, Issue 5 promotional card',
       'Hobby League 6 participation card A',
       "Structure Deck: Dinosaur's Rage Special Edition",
       'The Sanctuary in the Sky',
       'Shonen Jump Scholastic Edition Vol. 9, Issue 1 promotional card',
       'Hobby League participation cards',
       'Shonen Jump Vol. 10, Issue 4 promotional card',
       'Yu-Gi-Oh! R promotional cards',
       'Invasion: Vengeance Sneak Peek Participation Card',
       'Shonen Jump Vol. 3, Issue 9 promotional card',
       'Shonen Jump Vol. 5, Issue 1 promotional card',
       'Tournament Pack 2009 Vol.3', 'Ancient Sanctuary',
       'National Championship 2011',
       'Shonen Jump Vol. 7, Issue 9 promotional card',
       'Tournament Pack 2009 Vol.4',
       'Hobby League 7 participation card A',
       'Shonen Jump Vol. 9, Issue 6 promotional card',
       'Structure Deck: Machine Re-Volt Special Edition',
       'Shonen Jump May 2008 subscription bonus',
       'Shonen Jump June/July 2011 subscription bonus',
       'Shonen Jump Vol. 7, Issue 3 promotional card',
       'Hobby League 6 participation card B', 'Invader of Darkness',
       'The Valuable Book promotional cards',
       'Shonen Jump August 2008 subscription bonus',
       "Yu-Gi-Oh! 5D's manga promotional cards",
       'Shonen Jump Vol. 3, Issue 11 promotional card',
       "Structure Deck: Dinosaur's Rage Special Set",
       'Shonen Jump Vol. 5, Issue 6 promotional card',
       'National Championship 2012',
       'Hobby League 7 participation card B',
       'Shonen Jump Vol. 9, Issue 8 promotional card',
       'Shonen Jump Vol. 6, Issue 9 promotional card', 'Duel Disk',
       'Hobby League 6 participation card C',
       'The Valuable Book character cards',
       'Shonen Jump Vol. 6, Issue 1 promotional card',
       'Shonen Jump May 2010 subscription bonus',
       'Shonen Jump Vol. 4, Issue 2 promotional card',
       'National Championship 2013',
       'Shonen Jump Vol. 7, Issue 11 promotional card',
       'Ultimate Edition', 'Curse of Anubis',
       'Hobby League 7 participation card C',
       'Shonen Jump Vol. 9, Issue 10 promotional card',
       'Shonen Jump Championship Series Prize Cards',
       'Shonen Jump Vol. 9, Issue 1 promotional card',
       'Hobby League 6 participation card D', '2013 Collectible Tins',
       '20th Anniversary Duel Set', 'Booster Pack Tin Series Promos',
       'Chinese Weekly Shōnen Jump lottery prize cards',
       'Collectible Tins 2005', 'Collectible Tins 2006',
       'Collectible Tins 2007', 'Collectible Tins 2008',
       'Collectible Tins 2008 Wave 2', 'Collectible Tins 2009',
       'Collectible Tins 2010', 'Collectible Tins 2011',
       'Collectible Tins 2012',
       'Continuous Token Gifts Promotional Cards', 'Demo Pack',
       'Duelist League 18 participation cards',
       'Duelist League Series 1 participation cards',
       'Duelist League Series 2 participation cards',
       'Duelist Pack: Yugi', 'Exclusive Pack', 'Ghosts From the Past',
       'Judge promotional cards', 'Academia Disk',
       'Structure Deck: Marik (disambiguation)'], dtype=object)

Merge failed¶

Set Card number Name Rarity Print Quantity Region Release Series Set type Cover card Page URL Modification date _merge
156162 Academia Disk <NA> <NA> NaN <NA> <NA> <NA> NaT <NA> <NA> NaN https://yugipedia.com/wiki/Academia_Disk 2022-12-28 20:46:20 right_only
156163 Structure Deck: Marik (disambiguation) <NA> <NA> NaN <NA> <NA> <NA> NaT <NA> <NA> NaN https://yugipedia.com/wiki/Structure_Deck:_Mar... 2014-07-03 18:52:14 right_only 
8
array(['Absolute Powerforce: Special Edition',
       'Advanced Tournament Pack 2013 Vol.3',
       'Breakers of Shadow Sneak Peek Participation Card', ...,
       'Jump Festa 2005 promotional cards', 'Academia Disk',
       'Structure Deck: Marik (disambiguation)'], dtype=object)
Set Card number Name Rarity Print Quantity Region Release Series Set type Cover card Page URL Modification date _merge

Epilogue¶

Execution completed 03/02/2023 16:26 UTC

HTML export¶

Notebook saved to disk